Developed an Excel-based dashboard revealing key trends in $435.8M loan data, empowering stakeholders to optimize risk and drive informed lending decisions.

Conducted in-depth domain research on the financial industry, gaining a comprehensive understanding of loan types, grading systems, and repayment patterns. This knowledge enabled precise segmentation of loan data and the creation of insights tailored to the needs of financial stakeholders, showcasing strong business analysis capabilities.

Designed and developed a comprehensive dashboard in MS Excel, analyzing 38.6K loan applications with a total funded amount of $435.8M.

Performed data preprocessing and cleaning to ensure accurate and insightful analysis, categorizing loans into good (89.18%) and bad segments, and further segmenting data by loan grades and purposes.

Created dynamic monthly charts and integrated a geographic map to visualize loan applications by state, uncovering regional trends and loan distribution patterns.

Impact: Delivered actionable insights to assist stakeholders in understanding loan performance, optimizing risk management strategies, and identifying areas for financial growth and improvement, leveraging deep domain knowledge of the financial industry.